StockMeterReading

Entity Definition

Logical Name : StockMeterReading
Physical Name : DO_RDG_MTR_STK

The value of a STOCK METER recorded at a particular time for a particular reason.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer StockMeter(AS_MTR_STK)
StockMeterID (FK)(PK) A unique identifier for the stock meter ID_MTR_STK Identity integer StockMeter(AS_MTR_STK)
ReadingNumber (PK) A sequential number for a stock meter reading. AI_RDG LineNumber smallint
MeterValue The value of the STOCK METER at the time of the reading QY_RDG Quantity decimal(9,2)
TimeStamp The date & time the meter reading was taken TS_RDG AuditDateTime datetime
ReasonCode A 2character code denoting the reason the meter reading was taken RC_RDG Code varchar(20)
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) ForecourtSettlementTransaction(TR_STLM_FCRT)

Relationships

Parent Entity Verb Phrase Child Entity
ForecourtSettlementTransaction causes StockMeterReading
StockMeter records StockMeterReading

Logical Views containing StockMeterReading

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20040 - Forecourt History View